 >>  MySQLTuner 1.7.13 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 10.1.30-MariaDB
[OK] Operating on 64-bit architecture

-------- Log file Recommendations ------------------------------------------------------                                                                                                                                                     ------------
[--] Log file: /var/lib/mysql/Filter.globalvision.net.err(5G)
[OK] Log file /var/lib/mysql/Filter.globalvision.net.err exists
[OK] Log file /var/lib/mysql/Filter.globalvision.net.err is readable.
[OK] Log file /var/lib/mysql/Filter.globalvision.net.err is not empty
[!!] Log file /var/lib/mysql/Filter.globalvision.net.err is bigger than 32 Mb
[!!] /var/lib/mysql/Filter.globalvision.net.err contains 101018 warning(s).
[!!] /var/lib/mysql/Filter.globalvision.net.err contains 1394 error(s).
[--] 46 start(s) detected in /var/lib/mysql/Filter.globalvision.net.err
[--] 1) 2018-11-05 10:51:37 140362105997344 [Note] /usr/sbin/mysqld: ready for connectio                                                                                                                                                     ns.
[--] 2) 2018-10-29 15:06:45 139644262033440 [Note] /usr/sbin/mysqld: ready for connectio                                                                                                                                                     ns.
[--] 3) 2018-10-24 14:30:17 139993893914656 [Note] /usr/sbin/mysqld: ready for connectio                                                                                                                                                     ns.
[--] 4) 2018-10-24  8:55:11 140018579519520 [Note] /usr/sbin/mysqld: ready for connectio                                                                                                                                                     ns.
[--] 5) 2018-10-13 23:35:15 140495614265376 [Note] /usr/sbin/mysqld: ready for connectio                                                                                                                                                     ns.
[--] 6) 2018-10-13 22:16:07 139636403722272 [Note] /usr/sbin/mysqld: ready for connectio                                                                                                                                                     ns.
[--] 7) 2018-10-11  9:17:03 140051017586720 [Note] /usr/sbin/mysqld: ready for connectio                                                                                                                                                     ns.
[--] 8) 2018-09-27 11:46:16 139696984684576 [Note] /usr/sbin/mysqld: ready for connectio                                                                                                                                                     ns.
[--] 9) 2018-09-27 11:41:41 140345800951840 [Note] /usr/sbin/mysqld: ready for connectio                                                                                                                                                     ns.
[--] 10) 2018-09-17  9:17:51 139668486842400 [Note] /usr/sbin/mysqld: ready for connecti                                                                                                                                                     ons.
[--] 37 shutdown(s) detected in /var/lib/mysql/Filter.globalvision.net.err
[--] 1) 2018-11-05 10:49:30 139643186301696 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 2) 2018-10-29 15:06:40 139992940669696 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 3) 2018-10-24 14:28:28 140018578295552 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 4) 2018-10-24  8:53:16 140494482959104 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 5) 2018-10-13 22:14:04 140050998082304 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 6) 2018-10-11  9:15:02 139696222083840 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 7) 2018-09-27 11:44:10 140345800030976 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 8) 2018-09-27 11:41:35 139667352111872 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 9) 2018-09-17  9:15:45 140472767826688 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 10) 2018-09-07 13:43:43 139915544263424 [Note] /usr/sbin/mysqld: Shutdown complete

-------- Storage Engine Statistics -----------------------------------------------------                                                                                                                                                     ------------
[--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENC                                                                                                                                                     E
[--] Data in MyISAM tables: 93.3M (Tables: 14)
[--] Data in InnoDB tables: 13.8G (Tables: 21)
[!!] Total fragmented tables: 1

-------- Analysis Performance Metrics --------------------------------------------------                                                                                                                                                     ------------
[--] innodb_stats_on_metadata: OFF
[OK] No stat updates during querying INFORMATION_SCHEMA.

-------- Security Recommendations ------------------------------------------------------                                                                                                                                                     ------------
[OK] There are no anonymous accounts for any database users
[OK] All database users have passwords assigned
[!!] There is no basic password file list!

-------- CVE Security Recommendations --------------------------------------------------                                                                                                                                                     ------------
[--] Skipped due to --cvefile option undefined

-------- Performance Metrics -----------------------------------------------------------                                                                                                                                                     ------------
[--] Up for: 1h 30m 7s (219K q [40.513 qps], 2K conn, TX: 6G, RX: 53M)
[--] Reads / Writes: 45% / 55%
[--] Binary logging is disabled
[--] Physical Memory     : 15.6G
[--] Max MySQL memory    : 864.0M
[--] Other process memory: 3.0G
[--] Total buffers: 425.0M global + 2.9M per thread (151 max threads)
[--] P_S Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 442.4M (2.77% of installed RAM)
[OK] Maximum possible memory usage: 864.0M (5.42% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory availabl                                                                                                                                                     e
[OK] Slow queries: 0% (1K/219K)
[OK] Highest usage of available connections: 3% (6/151)
[OK] Aborted connections: 0.05%  (1/2076)
[!!] name resolution is active : a reverse name resolution is made for each new connecti                                                                                                                                                     on and can reduce performance
[!!] Query cache may be disabled by default due to mutex contention.
[!!] Query cache efficiency: 0.0% (0 cached / 95K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 8 sorts)
[!!] Joins performed without indexes: 64
[!!] Temporary tables created on disk: 60% (157 on disk / 258 total)
[!!] Thread cache is disabled
[OK] Table cache hit rate: 94% (132 open / 140 opened)
[OK] Open file limit used: 3% (130/4K)
[OK] Table locks acquired immediately: 99% (210K immediate / 210K locks)

-------- Performance schema ------------------------------------------------------------                                                                                                                                                     ------------
[--] Performance schema is disabled.
[--] Memory used by P_S: 0B
[--] Sys schema isn't installed.

-------- ThreadPool Metrics ------------------------------------------------------------                                                                                                                                                     ------------
[--] ThreadPool stat is enabled.
[--] Thread Pool Size: 8 thread(s).
[--] Using default value is good enough for your version (10.1.30-MariaDB)

-------- MyISAM Metrics ----------------------------------------------------------------                                                                                                                                                     ------------
[!!] Key buffer used: 33.3% (44M used / 134M cache)
[OK] Key buffer size / total MyISAM indexes: 128.0M/47.6M
[OK] Read Key buffer hit rate: 100.0% (2M cached / 1K reads)
[!!] Write Key buffer hit rate: 3.4% (700K cached / 24K writes)

-------- InnoDB Metrics ----------------------------------------------------------------                                                                                                                                                     ------------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[!!] InnoDB buffer pool / data size: 128.0M/13.8G
[!!] Ratio InnoDB log file size / InnoDB Buffer pool size (75 %): 48.0M * 2/128.0M shoul                                                                                                                                                     d be equal 25%
[!!] InnoDB buffer pool <= 1G and Innodb_buffer_pool_instances(!=1).
[--] InnoDB Buffer Pool Chunk Size not used or defined in your version
[OK] InnoDB Read buffer efficiency: 96.24% (28861624 hits/ 29990731 total)
[!!] InnoDB Write Log efficiency: 78.36% (419148 hits/ 534870 total)
[OK] InnoDB log waits: 0.00% (0 waits / 115722 writes)

-------- AriaDB Metrics ----------------------------------------------------------------                                                                                                                                                     ------------
[--] AriaDB is enabled.
[OK] Aria pagecache size / total Aria indexes: 128.0M/1B
[OK] Aria pagecache hit rate: 99.2% (20K cached / 157 reads)

-------- TokuDB Metrics ----------------------------------------------------------------                                                                                                                                                     ------------
[--] TokuDB is disabled.

-------- XtraDB Metrics ----------------------------------------------------------------                                                                                                                                                     ------------
[--] XtraDB is disabled.

-------- Galera Metrics ----------------------------------------------------------------                                                                                                                                                     ------------
[--] Galera is disabled.

-------- Replication Metrics -----------------------------------------------------------                                                                                                                                                     ------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] Binlog format: STATEMENT
[--] XA support enabled: ON
[--] Semi synchronous replication Master: Not Activated
[--] Semi synchronous replication Slave: Not Activated
[--] This is a standalone server

-------- Recommendations ---------------------------------------------------------------                                                                                                                                                     ------------
General recommendations:
    /var/lib/mysql/Filter.globalvision.net.err is > 32Mb, you should analyze why or impl                                                                                                                                                     ement a rotation log strategy such as logrotate!
    Control warning line(s) into /var/lib/mysql/Filter.globalvision.net.err file
    Control error line(s) into /var/lib/mysql/Filter.globalvision.net.err file
    Run OPTIMIZE TABLE to defragment tables for better performance
      OPTIMIZE TABLE `mailscanner`.`maillog`; -- can free 4090 MB
    Total freed space after theses OPTIMIZE TABLE : 4090 Mb
    MySQL was started within the last 24 hours - recommendations may be inaccurate
    Configure your accounts with ip or subnets only, then update your configuration with                                                                                                                                                      skip-name-resolve=1
    Adjust your join queries to always utilize indexes
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries which have no LIMIT clause
    Set thread_cache_size to 4 as a starting value
    Performance schema should be activated for better diagnostics
    Consider installing Sys schema from https://github.com/mysql/mysql-sys
    Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: htt                                                                                                                                                     p://bit.ly/2wgkDvS
Variables to adjust:
    query_cache_size (=0)
    query_cache_type (=0)
    query_cache_limit (> 1M, or use smaller result sets)
    join_buffer_size (> 256.0K, or always use indexes with JOINs)
    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)
    thread_cache_size (start at 4)
    performance_schema = ON enable PFS
    innodb_buffer_pool_size (>= 13.8G) if possible.
    innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size eq                                                                                                                                                     uals to 25% of buffer pool size.
    innodb_buffer_pool_instances (=1)
